Overview

Dataset info

Number of variables182
Number of observations555
Missing cells67353 (66.7%)
Duplicate rows0 (0.0%)
Total size in memory736.1 KiB
Average record size in memory1.3 KiB

Variables types

Numeric30
Categorical23
Boolean33
Date0
URL0
Text (Unique)1
Rejected95
Unsupported0

Warnings

coligada_mais_antiga_ativa has 493 (88.8%) missing values Missing
coligada_mais_antiga_baixada has constant value "nan" Rejected
coligada_mais_nova_ativa has 493 (88.8%) missing values Missing
coligada_mais_nova_baixada has constant value "nan" Rejected
de_faixa_faturamento_estimado has 25 (4.5%) missing values Missing
de_faixa_faturamento_estimado_grupo has 25 (4.5%) missing values Missing
de_indicador_telefone has 501 (90.3%) missing values Missing
de_saude_rescencia has 11 (2.0%) missing values Missing
de_saude_tributaria has 11 (2.0%) missing values Missing
dt_situacao only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
dt_situacao has a high cardinality: 416 distinct values Warning
empsetorcensitariofaixarendapopulacao has 150 (27.0%) missing values Missing
faturamento_est_coligados has 493 (88.8%) missing values Missing
faturamento_est_coligados_gp is highly correlated with faturamento_est_coligados (ρ = 0.9798738459) Rejected
fl_epp has constant value "False" Rejected
fl_ltda has constant value "False" Rejected
fl_optante_simei has 101 (18.2%) missing values Missing
fl_optante_simples has 101 (18.2%) missing values Missing
fl_simples_irregular has constant value "False" Rejected
fl_spa has constant value "False" Rejected
fl_st_especial has constant value "False" Rejected
grau_instrucao_macro_analfabeto has 554 (99.8%) missing values Missing
grau_instrucao_macro_desconhecido has constant value "nan" Rejected
grau_instrucao_macro_escolaridade_fundamental has 530 (95.5%) missing values Missing
grau_instrucao_macro_escolaridade_media has 469 (84.5%) missing values Missing
grau_instrucao_macro_escolaridade_superior has 532 (95.9%) missing values Missing
idade_acima_de_58 is highly correlated with grau_instrucao_macro_escolaridade_fundamental (ρ = 0.9173649446) Rejected
idade_ate_18 has 551 (99.3%) missing values Missing
idade_de_19_a_23 is highly correlated with idade_acima_de_58 (ρ = 0.9432422183) Rejected
idade_de_24_a_28 has 509 (91.7%) missing values Missing
idade_de_29_a_33 is highly correlated with grau_instrucao_macro_escolaridade_media (ρ = 0.9270644425) Rejected
idade_de_34_a_38 has 513 (92.4%) missing values Missing
idade_de_39_a_43 has 523 (94.2%) missing values Missing
idade_de_44_a_48 has 534 (96.2%) missing values Missing
idade_de_49_a_53 is highly correlated with idade_de_29_a_33 (ρ = 0.9490484453) Rejected
idade_de_54_a_58 is highly correlated with idade_de_34_a_38 (ρ = 0.9779514754) Rejected
idade_maxima_coligadas is highly correlated with coligada_mais_antiga_ativa (ρ = 1) Rejected
idade_maxima_socios has 193 (34.8%) missing values Missing
idade_media_coligadas has 492 (88.6%) missing values Missing
idade_media_coligadas_ativas is highly correlated with idade_media_coligadas (ρ = 1) Rejected
idade_media_coligadas_baixadas has constant value "nan" Rejected
idade_media_socios is highly correlated with idade_maxima_socios (ρ = 0.9663386807) Rejected
idade_minima_coligadas is highly correlated with coligada_mais_nova_ativa (ρ = 1) Rejected
idade_minima_socios is highly correlated with idade_media_socios (ρ = 0.9672309258) Rejected
max_faturamento_est_coligados is highly correlated with faturamento_est_coligados_gp (ρ = 0.9753288607) Rejected
max_faturamento_est_coligados_gp is highly correlated with max_faturamento_est_coligados (ρ = 0.9208848359) Rejected
max_filiais_coligados has 540 (97.3%) missing values Missing
max_funcionarios_coligados_gp is highly correlated with max_faturamento_est_coligados_gp (ρ = 0.9988162351) Rejected
max_meses_servicos has 454 (81.8%) missing values Missing
max_meses_servicos_all has 424 (76.4%) missing values Missing
max_vl_folha_coligados is highly correlated with max_faturamento_est_coligados (ρ = 0.9432797848) Rejected
max_vl_folha_coligados_gp is highly correlated with max_funcionarios_coligados_gp (ρ = 0.9830355726) Rejected
media_faturamento_est_coligados is highly correlated with max_funcionarios_coligados_gp (ρ = 0.9460011571) Rejected
media_faturamento_est_coligados_gp has 493 (88.8%) missing values Missing
media_filiais_coligados is highly correlated with max_filiais_coligados (ρ = 0.984817247) Rejected
media_funcionarios_coligados_gp is highly correlated with media_filiais_coligados (ρ = 0.9290150933) Rejected
media_meses_servicos has 454 (81.8%) missing values Missing
media_meses_servicos_all is highly correlated with max_meses_servicos_all (ρ = 0.9651590156) Rejected
media_vl_folha_coligados is highly correlated with media_faturamento_est_coligados (ρ = 0.9023282866) Rejected
media_vl_folha_coligados_gp is highly correlated with media_funcionarios_coligados_gp (ρ = 0.9956423815) Rejected
meses_ultima_contratacaco has 424 (76.4%) missing values Missing
min_faturamento_est_coligados is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.9401087019) Rejected
min_faturamento_est_coligados_gp is highly correlated with min_faturamento_est_coligados (ρ = 0.9857654776) Rejected
min_filiais_coligados is highly correlated with media_vl_folha_coligados_gp (ρ = 0.9113088103) Rejected
min_funcionarios_coligados_gp is highly correlated with min_faturamento_est_coligados_gp (ρ = 0.9974669262) Rejected
min_meses_servicos has 454 (81.8%) missing values Missing
min_meses_servicos_all has 424 (76.4%) missing values Missing
min_vl_folha_coligados is highly correlated with min_faturamento_est_coligados (ρ = 0.9115581462) Rejected
min_vl_folha_coligados_gp is highly correlated with min_funcionarios_coligados_gp (ρ = 0.9997894656) Rejected
nm_meso_regiao has 64 (11.5%) missing values Missing
nm_micro_regiao has a high cardinality: 67 distinct values Warning
nm_micro_regiao has 64 (11.5%) missing values Missing
nu_meses_rescencia has 47 (8.5%) missing values Missing
percent_func_genero_fem has 22 (4.0%) zeros Zeros
percent_func_genero_fem has 454 (81.8%) missing values Missing
percent_func_genero_masc has 32 (5.8%) zeros Zeros
percent_func_genero_masc has 454 (81.8%) missing values Missing
qt_admitidos has 424 (76.4%) missing values Missing
qt_admitidos_12meses has 89 (16.0%) zeros Zeros
qt_admitidos_12meses has 424 (76.4%) missing values Missing
qt_alteracao_socio_180d has constant value "nan" Rejected
qt_alteracao_socio_365d has constant value "nan" Rejected
qt_alteracao_socio_90d has constant value "nan" Rejected
qt_alteracao_socio_total has constant value "nan" Rejected
qt_art is highly correlated with qt_admitidos (ρ = 1) Rejected
qt_coligadas is highly correlated with min_filiais_coligados (ρ = 0.9682511623) Rejected
qt_coligados is highly correlated with qt_coligadas (ρ = 0.9974819746) Rejected
qt_coligados_agropecuaria has 492 (88.6%) missing values Missing
qt_coligados_atividade_alto has 492 (88.6%) missing values Missing
qt_coligados_atividade_baixo has 492 (88.6%) missing values Missing
qt_coligados_atividade_inativo has 492 (88.6%) missing values Missing
qt_coligados_atividade_medio has 492 (88.6%) missing values Missing
qt_coligados_atividade_mt_baixo has 492 (88.6%) missing values Missing
qt_coligados_ativo has 492 (88.6%) missing values Missing
qt_coligados_baixada has 492 (88.6%) missing values Missing
qt_coligados_ccivil is highly correlated with qt_art (ρ = 1) Rejected
qt_coligados_centro is highly correlated with qt_coligadas (ρ = 0.9142772641) Rejected
qt_coligados_comercio has 21 (3.8%) zeros Zeros
qt_coligados_comercio has 492 (88.6%) missing values Missing
qt_coligados_epp has 492 (88.6%) missing values Missing
qt_coligados_exterior has 492 (88.6%) missing values Missing
qt_coligados_inapta has 492 (88.6%) missing values Missing
qt_coligados_industria is highly correlated with qt_coligados_ccivil (ρ = 0.9011165757) Rejected
qt_coligados_ltda is highly correlated with qt_coligados_centro (ρ = 1) Rejected
qt_coligados_matriz is highly correlated with qt_coligados (ρ = 0.991544335) Rejected
qt_coligados_me has 492 (88.6%) missing values Missing
qt_coligados_mei has 492 (88.6%) missing values Missing
qt_coligados_nordeste is highly correlated with qt_coligados_ativo (ρ = 0.9006896596) Rejected
qt_coligados_norte is highly correlated with qt_art (ρ = 1) Rejected
qt_coligados_nula has 492 (88.6%) missing values Missing
qt_coligados_sa is highly correlated with qt_coligados_industria (ρ = 0.9802385571) Rejected
qt_coligados_serviço is highly correlated with max_vl_folha_coligados (ρ = 0.9134551877) Rejected
qt_coligados_sudeste is highly correlated with qt_coligados_ltda (ρ = 0.9443641162) Rejected
qt_coligados_sul has 492 (88.6%) missing values Missing
qt_coligados_suspensa has 492 (88.6%) missing values Missing
qt_desligados is highly correlated with qt_art (ρ = 1) Rejected
qt_desligados_12meses is highly correlated with qt_art (ρ = 1) Rejected
qt_ex_funcionarios is highly correlated with qt_desligados (ρ = 0.9999417874) Rejected
qt_filiais is highly correlated with qt_coligados_sa (ρ = 0.9757969605) Rejected
qt_funcionarios is highly correlated with idade_de_49_a_53 (ρ = 0.9326400842) Rejected
qt_funcionarios_12meses is highly correlated with qt_funcionarios (ρ = 0.9757958364) Rejected
qt_funcionarios_24meses is highly correlated with qt_admitidos (ρ = 0.9220046051) Rejected
qt_funcionarios_coligados is highly correlated with qt_filiais (ρ = 0.9495362911) Rejected
qt_funcionarios_coligados_gp is highly correlated with qt_funcionarios_coligados (ρ = 0.971940039) Rejected
qt_funcionarios_grupo is highly correlated with qt_funcionarios_coligados_gp (ρ = 0.9157758137) Rejected
qt_ramos_coligados is highly correlated with qt_funcionarios_grupo (ρ = 0.966877865) Rejected
qt_regioes_coligados is highly correlated with qt_coligadas (ρ = 0.9142772641) Rejected
qt_socios has 147 (26.5%) missing values Missing
qt_socios_coligados is highly correlated with qt_coligados_ativo (ρ = 0.9824935146) Rejected
qt_socios_feminino has 365 (65.8%) missing values Missing
qt_socios_masculino is highly correlated with qt_art (ρ = 1) Rejected
qt_socios_pep is highly correlated with qt_socios_masculino (ρ = 1) Rejected
qt_socios_pf is highly correlated with qt_socios_pep (ρ = 1) Rejected
qt_socios_pj has 147 (26.5%) missing values Missing
qt_socios_pj_ativos is highly correlated with qt_socios_pj (ρ = 1) Rejected
qt_socios_pj_baixados has 553 (99.6%) missing values Missing
qt_socios_pj_inaptos has 553 (99.6%) missing values Missing
qt_socios_pj_nulos has 553 (99.6%) missing values Missing
qt_socios_pj_suspensos has 553 (99.6%) missing values Missing
qt_socios_st_regular is highly correlated with qt_socios_pep (ρ = 1) Rejected
qt_socios_st_suspensa has 548 (98.7%) missing values Missing
qt_ufs_coligados is highly correlated with qt_socios_pj_ativos (ρ = 1) Rejected
sum_faturamento_estimado_coligadas is highly correlated with qt_regioes_coligados (ρ = 0.9794843167) Rejected
total is highly correlated with qt_funcionarios_12meses (ρ = 0.9743791866) Rejected
total_filiais_coligados has 540 (97.3%) missing values Missing
tx_crescimento_12meses has 63 (11.4%) zeros Zeros
tx_crescimento_12meses has 458 (82.5%) missing values Missing
tx_crescimento_24meses is highly correlated with min_vl_folha_coligados_gp (ρ = 0.9675760839) Rejected
tx_rotatividade is highly correlated with qt_art (ρ = 1) Rejected
Unnamed_0 is highly correlated with qt_socios_pj_ativos (ρ = 1) Rejected
vl_faturamento_estimado_aux is highly correlated with qt_socios_pj_ativos (ρ = 1) Rejected
vl_faturamento_estimado_grupo_aux is highly correlated with qt_socios_pj_ativos (ρ = 1) Rejected
vl_folha_coligados is highly correlated with vl_faturamento_estimado_grupo_aux (ρ = 0.9801776077) Rejected
vl_folha_coligados_gp is highly correlated with vl_folha_coligados (ρ = 0.9769040844) Rejected
vl_frota is highly correlated with total_filiais_coligados (ρ = 1) Rejected
vl_idade_maxima_socios_pj is highly correlated with vl_faturamento_estimado_grupo_aux (ρ = 1) Rejected
vl_idade_media_socios_pj is highly correlated with nu_meses_rescencia (ρ = 1) Rejected
vl_idade_minima_socios_pj is highly correlated with vl_idade_media_socios_pj (ρ = 1) Rejected
vl_potenc_cons_oleo_gas is highly correlated with tx_crescimento_24meses (ρ = 1) Rejected
vl_total_tancagem has constant value "nan" Rejected
vl_total_tancagem_grupo has constant value "nan" Rejected
vl_total_veiculos_antt has constant value "nan" Rejected
vl_total_veiculos_antt_grupo has constant value "nan" Rejected
vl_total_veiculos_leves is highly correlated with total_filiais_coligados (ρ = 1) Rejected
vl_total_veiculos_leves_grupo is highly correlated with vl_idade_maxima_socios_pj (ρ = 1) Rejected
vl_total_veiculos_pesados is highly correlated with vl_potenc_cons_oleo_gas (ρ = 1) Rejected
vl_total_veiculos_pesados_grupo is highly correlated with vl_total_veiculos_leves_grupo (ρ = 0.9945105446) Rejected

Variables

coligada_mais_antiga_ativa
Numeric

Distinct count62
Unique (%)11.2%
Missing (%)88.8%
Missing (n)493
Infinite (%)0.0%
Infinite (n)0
Mean218.4887097
Minimum4.066666667
Maximum636.6
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4.066666667
5-th percentile19.97
Q190.18333333
Median191.1
Q3325.1333333
95-th percentile521.6433333
Maximum636.6
Range632.5333333
Interquartile range234.95

Descriptive statistics

Standard deviation165.7745939
Coef of variation0.7587329989
Kurtosis0.07860743476
Mean218.4887097
MAD130.713042
Skewness0.883628313
Sum13546.3
Variance27481.21599
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
27.73333333 2 0.4%
 
10.16666667 1 0.2%
 
521.8 1 0.2%
 
354.5333333 1 0.2%
 
87.7 1 0.2%
 
399.1666667 1 0.2%
 
383.2 1 0.2%
 
103.2666667 1 0.2%
 
93.73333333 1 0.2%
 
135.4666667 1 0.2%
 
Other values (51) 51 9.2%
 
(Missing) 493 88.8%
 

Minimum 5 values

ValueCountFrequency (%) 
4.066666667 1 0.2%
 
9.066666667 1 0.2%
 
10.16666667 1 0.2%
 
19.56666667 1 0.2%
 
27.63333333 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
636.6 1 0.2%
 
634.1666667 1 0.2%
 
611.2 1 0.2%
 
521.8 1 0.2%
 
518.6666667 1 0.2%
 

coligada_mais_antiga_baixada
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

coligada_mais_nova_ativa
Numeric

Distinct count62
Unique (%)11.2%
Missing (%)88.8%
Missing (n)493
Infinite (%)0.0%
Infinite (n)0
Mean121.3016129
Minimum1.566666667
Maximum476.0666667
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.566666667
5-th percentile5.041666667
Q124.35833333
Median91.36666667
Q3194.325
95-th percentile367.1716667
Maximum476.0666667
Range474.5
Interquartile range169.9666667

Descriptive statistics

Standard deviation117.362627
Coef of variation0.9675273408
Kurtosis1.343809131
Mean121.3016129
MAD91.36531391
Skewness1.286324323
Sum7520.7
Variance13773.98621
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
27.73333333 2 0.4%
 
125.6333333 1 0.2%
 
16.23333333 1 0.2%
 
1.566666667 1 0.2%
 
93.73333333 1 0.2%
 
135.4666667 1 0.2%
 
476.0666667 1 0.2%
 
225.0333333 1 0.2%
 
10.36666667 1 0.2%
 
194.3 1 0.2%
 
Other values (51) 51 9.2%
 
(Missing) 493 88.8%
 

Minimum 5 values

ValueCountFrequency (%) 
1.566666667 1 0.2%
 
4.066666667 1 0.2%
 
4.633333333 1 0.2%
 
4.866666667 1 0.2%
 
8.366666667 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
476.0666667 1 0.2%
 
450.0666667 1 0.2%
 
426.4333333 1 0.2%
 
368.2666667 1 0.2%
 
346.3666667 1 0.2%
 

coligada_mais_nova_baixada
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

de_faixa_faturamento_estimado
Categorical

Distinct count8
Unique (%)1.4%
Missing (%)4.5%
Missing (n)25
DE R$ 81.000,01 A R$ 360.000,00
325
ATE R$ 81.000,00
144
DE R$ 360.000,01 A R$ 1.500.000,00
 
41
Other values (4)
 
20
(Missing)
 
25
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 325 58.6%
 
ATE R$ 81.000,00 144 25.9%
 
DE R$ 360.000,01 A R$ 1.500.000,00 41 7.4%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 16 2.9%
 
SEM INFORMACAO 2 0.4%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 1 0.2%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 1 0.2%
 
(Missing) 25 4.5%
 
Max length38
Mean length26.17477477
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count10
Unique (%)1.8%
Missing (%)4.5%
Missing (n)25
DE R$ 81.000,01 A R$ 360.000,00
296
ATE R$ 81.000,00
143
DE R$ 360.000,01 A R$ 1.500.000,00
 
58
Other values (6)
 
33
(Missing)
 
25
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 296 53.3%
 
ATE R$ 81.000,00 143 25.8%
 
DE R$ 360.000,01 A R$ 1.500.000,00 58 10.5%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 18 3.2%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 6 1.1%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 5 0.9%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 2 0.4%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 1 0.2%
 
ACIMA DE 1 BILHAO DE REAIS 1 0.2%
 
(Missing) 25 4.5%
 
Max length40
Mean length26.51351351
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_indicador_telefone
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)90.3%
Missing (n)501
BOA
 
54
(Missing)
501
ValueCountFrequency (%) 
BOA 54 9.7%
 
(Missing) 501 90.3%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

de_natureza_juridica
Categorical

Distinct count6
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
EMPRESARIO INDIVIDUAL
432
SOCIEDADE EMPRESARIA LIMITADA
105
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA
 
15
Other values (3)
 
3
ValueCountFrequency (%) 
EMPRESARIO INDIVIDUAL 432 77.8%
 
SOCIEDADE EMPRESARIA LIMITADA 105 18.9%
 
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA 15 2.7%
 
SOCIEDADE ANONIMA FECHADA 1 0.2%
 
SOCIEDADE EM CONTA DE PARTICIPACAO 1 0.2%
 
SOCIEDADE EMPRESARIA EM NOME COLETIVO 1 0.2%
 
Max length70
Mean length23.8972973
Min length21
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_nivel_atividade
Categorical

Distinct count5
Unique (%)0.9%
Missing (%)0.7%
Missing (n)4
MEDIA
280
ALTA
153
BAIXA
116
(Missing)
 
4
ValueCountFrequency (%) 
MEDIA 280 50.5%
 
ALTA 153 27.6%
 
BAIXA 116 20.9%
 
MUITO BAIXA 2 0.4%
 
(Missing) 4 0.7%
 
Max length11
Mean length4.731531532
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_ramo
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
COMERCIO VAREJISTA
496
BENS DE CONSUMO
 
59
ValueCountFrequency (%) 
COMERCIO VAREJISTA 496 89.4%
 
BENS DE CONSUMO 59 10.6%
 
Max length18
Mean length17.68108108
Min length15
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_saude_rescencia
Categorical

Distinct count4
Unique (%)0.7%
Missing (%)2.0%
Missing (n)11
ACIMA DE 1 ANO
453
ATE 1 ANO
 
55
SEM INFORMACAO
 
36
(Missing)
 
11
ValueCountFrequency (%) 
ACIMA DE 1 ANO 453 81.6%
 
ATE 1 ANO 55 9.9%
 
SEM INFORMACAO 36 6.5%
 
(Missing) 11 2.0%
 
Max length14
Mean length13.28648649
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_saude_tributaria
Categorical

Distinct count7
Unique (%)1.3%
Missing (%)2.0%
Missing (n)11
VERDE
167
AZUL
128
AMARELO
113
Other values (3)
136
ValueCountFrequency (%) 
VERDE 167 30.1%
 
AZUL 128 23.1%
 
AMARELO 113 20.4%
 
CINZA 86 15.5%
 
LARANJA 47 8.5%
 
VERMELHO 3 0.5%
 
(Missing) 11 2.0%
 
Max length8
Mean length5.322522523
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

dt_situacao
Categorical

Distinct count416
Unique (%)75.0%
Missing (%)0.0%
Missing (n)0
2005-11-03
100
2010-10-26
 
4
2017-02-21
 
3
Other values (413)
448
ValueCountFrequency (%) 
2005-11-03 100 18.0%
 
2010-10-26 4 0.7%
 
2017-02-21 3 0.5%
 
2006-12-02 3 0.5%
 
2017-03-29 3 0.5%
 
2017-10-16 2 0.4%
 
2017-09-14 2 0.4%
 
2002-10-12 2 0.4%
 
2018-03-06 2 0.4%
 
2008-09-10 2 0.4%
 
Other values (406) 432 77.8%
 
Max length10
Mean length10
Min length10
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count392
Unique (%)70.6%
Missing (%)27.0%
Missing (n)150
Infinite (%)0.0%
Infinite (n)0
Mean1130.532765
Minimum110.3
Maximum6201.91
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum110.3
5-th percentile401.95
Q1643.07
Median905.94
Q31303.82
95-th percentile2460.026
Maximum6201.91
Range6091.61
Interquartile range660.75

Descriptive statistics

Standard deviation815.0382028
Coef of variation0.7209328449
Kurtosis9.551738645
Mean1130.532765
MAD537.2669602
Skewness2.705259278
Sum457865.77
Variance664287.272
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
555.9 2 0.4%
 
1316.48 2 0.4%
 
2361.38 2 0.4%
 
949.29 2 0.4%
 
609.88 2 0.4%
 
4640.24 2 0.4%
 
1660.52 2 0.4%
 
946.33 2 0.4%
 
1461.93 2 0.4%
 
2019.39 2 0.4%
 
Other values (381) 385 69.4%
 
(Missing) 150 27.0%
 

Minimum 5 values

ValueCountFrequency (%) 
110.3 1 0.2%
 
268.85 1 0.2%
 
284.92 1 0.2%
 
285.63 1 0.2%
 
305.93 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
6201.91 1 0.2%
 
5049.8 1 0.2%
 
4815.33 1 0.2%
 
4796.69 1 0.2%
 
4655.76 1 0.2%
 

faturamento_est_coligados
Numeric

Distinct count42
Unique (%)7.6%
Missing (%)88.8%
Missing (n)493
Infinite (%)0.0%
Infinite (n)0
Mean23987448.6
Minimum61819.19922
Maximum822198302.8
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum61819.19922
5-th percentile210000
Q1210000
Median605457.5938
Q31985474.438
95-th percentile33466988.08
Maximum822198302.8
Range822136483.6
Interquartile range1775474.438

Descriptive statistics

Standard deviation119192027
Coef of variation4.968933088
Kurtosis36.80524454
Mean23987448.6
MAD41381008.51
Skewness5.974394413
Sum1487221813
Variance1.420673931e+16
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=42)
ValueCountFrequency (%) 
210000 14 2.5%
 
420000 5 0.9%
 
370915.1875 3 0.5%
 
457276.7969 2 0.4%
 
556372.8125 2 0.4%
 
10929264 1 0.2%
 
630000 1 0.2%
 
5811005 1 0.2%
 
8820000 1 0.2%
 
1458191.992 1 0.2%
 
Other values (31) 31 5.6%
 
(Missing) 493 88.8%
 

Minimum 5 values

ValueCountFrequency (%) 
61819.19922 1 0.2%
 
185457.5938 1 0.2%
 
206064 1 0.2%
 
210000 14 2.5%
 
370915.1875 3 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
822198302.8 1 0.2%
 
470915908.8 1 0.2%
 
51000840 1 0.2%
 
34646006.56 1 0.2%
 
11065636.88 1 0.2%
 

faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation0.9798738459

fl_antt
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
551
True
 
4
ValueCountFrequency (%) 
False 551 99.3%
 
True 4 0.7%
 

fl_email
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
300
True
255
ValueCountFrequency (%) 
False 300 54.1%
 
True 255 45.9%
 

fl_epp
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_ltda
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_matriz
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
True
519
False
 
36
ValueCountFrequency (%) 
True 519 93.5%
 
False 36 6.5%
 

fl_me
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
553
True
 
2
ValueCountFrequency (%) 
False 553 99.6%
 
True 2 0.4%
 

fl_mei
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
337
True
218
ValueCountFrequency (%) 
False 337 60.7%
 
True 218 39.3%
 

fl_optante_simei
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)18.2%
Missing (n)101
False
316
True
138
(Missing)
101
ValueCountFrequency (%) 
False 316 56.9%
 
True 138 24.9%
 
(Missing) 101 18.2%
 

fl_optante_simples
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)18.2%
Missing (n)101
True
286
False
168
(Missing)
101
ValueCountFrequency (%) 
True 286 51.5%
 
False 168 30.3%
 
(Missing) 101 18.2%
 

fl_passivel_iss
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
442
True
113
ValueCountFrequency (%) 
False 442 79.6%
 
True 113 20.4%
 

fl_rm
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
NAO
311
SIM
244
ValueCountFrequency (%) 
NAO 311 56.0%
 
SIM 244 44.0%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

fl_sa
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
546
True
 
9
ValueCountFrequency (%) 
False 546 98.4%
 
True 9 1.6%
 

fl_simples_irregular
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_spa
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_st_especial
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_telefone
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
True
400
False
155
ValueCountFrequency (%) 
True 400 72.1%
 
False 155 27.9%
 

fl_veiculo
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
517
True
 
38
ValueCountFrequency (%) 
False 517 93.2%
 
True 38 6.8%
 

grau_instrucao_macro_analfabeto
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)99.8%
Missing (n)554
1
 
1
(Missing)
554
ValueCountFrequency (%) 
1 1 0.2%
 
(Missing) 554 99.8%
 

grau_instrucao_macro_desconhecido
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

grau_instrucao_macro_escolaridade_fundamental
Numeric

Distinct count8
Unique (%)1.4%
Missing (%)95.5%
Missing (n)530
Infinite (%)0.0%
Infinite (n)0
Mean3.56
Minimum1
Maximum25
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q33
95-th percentile13.8
Maximum25
Range24
Interquartile range2

Descriptive statistics

Standard deviation5.60565191
Coef of variation1.574621323
Kurtosis9.144672007
Mean3.56
MAD3.3408
Skewness2.982660228
Sum89
Variance31.42333333
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%) 
1 13 2.3%
 
3 4 0.7%
 
2 4 0.7%
 
4 1 0.2%
 
14 1 0.2%
 
25 1 0.2%
 
13 1 0.2%
 
(Missing) 530 95.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 13 2.3%
 
2 4 0.7%
 
3 4 0.7%
 
4 1 0.2%
 
13 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
25 1 0.2%
 
14 1 0.2%
 
13 1 0.2%
 
4 1 0.2%
 
3 4 0.7%
 

grau_instrucao_macro_escolaridade_media
Numeric

Distinct count18
Unique (%)3.2%
Missing (%)84.5%
Missing (n)469
Infinite (%)0.0%
Infinite (n)0
Mean5.337209302
Minimum1
Maximum70
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median3
Q36
95-th percentile13.75
Maximum70
Range69
Interquartile range5

Descriptive statistics

Standard deviation9.030159226
Coef of variation1.691925258
Kurtosis32.58669716
Mean5.337209302
MAD4.664413196
Skewness5.124474064
Sum459
Variance81.54377565
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%) 
1 33 5.9%
 
3 9 1.6%
 
2 8 1.4%
 
6 8 1.4%
 
4 6 1.1%
 
5 5 0.9%
 
11 3 0.5%
 
9 3 0.5%
 
7 2 0.4%
 
13 2 0.4%
 
Other values (7) 7 1.3%
 
(Missing) 469 84.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 33 5.9%
 
2 8 1.4%
 
3 9 1.6%
 
4 6 1.1%
 
5 5 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
70 1 0.2%
 
38 1 0.2%
 
24 1 0.2%
 
18 1 0.2%
 
14 1 0.2%
 

grau_instrucao_macro_escolaridade_superior
Categorical

Distinct count5
Unique (%)0.9%
Missing (%)95.9%
Missing (n)532
1
 
17
2
 
4
4
 
1
(Missing)
532
ValueCountFrequency (%) 
1 17 3.1%
 
2 4 0.7%
 
4 1 0.2%
 
3 1 0.2%
 
(Missing) 532 95.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

id
Categorical, Unique

First 5 values
00b5cef5652ca3e33f15cbab7249b9d1dc06c82df26d76...
00b79c8f0f8a5ac93fa441f42b1619846dd2aaa5ddf2b3...
013ce96aef919fb847b8f0cfc882a1ebad64e291e78ff6...
01f73b5d6d29e955d5f8862698a291a961a3fde5848de6...
02183ea423d627596a8a243492f07e048d3cb59ea1114d...
Last 5 values
feec91169df886e0b49f9625deb4fbb8614e0002788d8f...
ff4ad7a26c1ef7ec42bf5ec66888c43203f44bac4e9d53...
ff633fd9711d44def1878bf872343c4c32ca97a3e2c290...
ff94dca46aa53e42898307c53a702f357bb19cedb4b662...
ffd7c9bf8cb8089dffcceb22e5d84dc2814c5658f27e04...

First 5 values

ValueCountFrequency (%) 
00b5cef5652ca3e33f15cbab7249b9d1dc06c82df26d76d94f94834d2aba3b29 1 0.2%
 
00b79c8f0f8a5ac93fa441f42b1619846dd2aaa5ddf2b3c3c79c599e1202a16d 1 0.2%
 
013ce96aef919fb847b8f0cfc882a1ebad64e291e78ff61a1988ac3d30c0fe39 1 0.2%
 
01f73b5d6d29e955d5f8862698a291a961a3fde5848de6018e6e251a9bd7aeeb 1 0.2%
 
02183ea423d627596a8a243492f07e048d3cb59ea1114d80704dac0d1d35797d 1 0.2%
 

Last 5 values

ValueCountFrequency (%) 
ffd7c9bf8cb8089dffcceb22e5d84dc2814c5658f27e04cc8b9c69f56f2e94fd 1 0.2%
 
ff94dca46aa53e42898307c53a702f357bb19cedb4b662aff5e1678f015d6637 1 0.2%
 
ff633fd9711d44def1878bf872343c4c32ca97a3e2c290ab7214d5e6a99cab26 1 0.2%
 
ff4ad7a26c1ef7ec42bf5ec66888c43203f44bac4e9d532c43affbd9273a724e 1 0.2%
 
feec91169df886e0b49f9625deb4fbb8614e0002788d8f88fbdbc3f80d464b28 1 0.2%
 

idade_acima_de_58
Highly correlated

This variable is highly correlated with grau_instrucao_macro_escolaridade_fundamental and should be ignored for analysis

Correlation0.9173649446

idade_ate_18
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)99.3%
Missing (n)551
1
 
4
(Missing)
551
ValueCountFrequency (%) 
1 4 0.7%
 
(Missing) 551 99.3%
 

idade_de_19_a_23
Highly correlated

This variable is highly correlated with idade_acima_de_58 and should be ignored for analysis

Correlation0.9432422183

idade_de_24_a_28
Numeric

Distinct count9
Unique (%)1.6%
Missing (%)91.7%
Missing (n)509
Infinite (%)0.0%
Infinite (n)0
Mean2.652173913
Minimum1
Maximum11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q33
95-th percentile8.75
Maximum11
Range10
Interquartile range2

Descriptive statistics

Standard deviation2.442379453
Coef of variation0.9208971707
Kurtosis3.362463233
Mean2.652173913
MAD1.792060491
Skewness1.92634963
Sum122
Variance5.965217391
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
1 21 3.8%
 
2 10 1.8%
 
5 4 0.7%
 
3 4 0.7%
 
4 3 0.5%
 
9 2 0.4%
 
8 1 0.2%
 
11 1 0.2%
 
(Missing) 509 91.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 21 3.8%
 
2 10 1.8%
 
3 4 0.7%
 
4 3 0.5%
 
5 4 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
11 1 0.2%
 
9 2 0.4%
 
8 1 0.2%
 
5 4 0.7%
 
4 3 0.5%
 

idade_de_29_a_33
Highly correlated

This variable is highly correlated with grau_instrucao_macro_escolaridade_media and should be ignored for analysis

Correlation0.9270644425

idade_de_34_a_38
Numeric

Distinct count8
Unique (%)1.4%
Missing (%)92.4%
Missing (n)513
Infinite (%)0.0%
Infinite (n)0
Mean2.238095238
Minimum1
Maximum12
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile5.95
Maximum12
Range11
Interquartile range1

Descriptive statistics

Standard deviation2.535691793
Coef of variation1.132968673
Kurtosis9.435850017
Mean2.238095238
MAD1.56462585
Skewness3.00825859
Sum94
Variance6.429732869
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%) 
1 25 4.5%
 
2 8 1.4%
 
3 3 0.5%
 
5 2 0.4%
 
12 2 0.4%
 
4 1 0.2%
 
6 1 0.2%
 
(Missing) 513 92.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 25 4.5%
 
2 8 1.4%
 
3 3 0.5%
 
4 1 0.2%
 
5 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
12 2 0.4%
 
6 1 0.2%
 
5 2 0.4%
 
4 1 0.2%
 
3 3 0.5%
 

idade_de_39_a_43
Numeric

Distinct count9
Unique (%)1.6%
Missing (%)94.2%
Missing (n)523
Infinite (%)0.0%
Infinite (n)0
Mean2.28125
Minimum1
Maximum11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile8.9
Maximum11
Range10
Interquartile range1

Descriptive statistics

Standard deviation2.726623518
Coef of variation1.195232227
Kurtosis4.276323234
Mean2.28125
MAD1.89453125
Skewness2.270870962
Sum73
Variance7.434475806
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
1 23 4.1%
 
2 3 0.5%
 
6 1 0.2%
 
5 1 0.2%
 
11 1 0.2%
 
8 1 0.2%
 
10 1 0.2%
 
4 1 0.2%
 
(Missing) 523 94.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 23 4.1%
 
2 3 0.5%
 
4 1 0.2%
 
5 1 0.2%
 
6 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
11 1 0.2%
 
10 1 0.2%
 
8 1 0.2%
 
6 1 0.2%
 
5 1 0.2%
 

idade_de_44_a_48
Categorical

Distinct count5
Unique (%)0.9%
Missing (%)96.2%
Missing (n)534
1
 
16
2
 
3
5
 
1
(Missing)
534
ValueCountFrequency (%) 
1 16 2.9%
 
2 3 0.5%
 
5 1 0.2%
 
3 1 0.2%
 
(Missing) 534 96.2%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

idade_de_49_a_53
Highly correlated

This variable is highly correlated with idade_de_29_a_33 and should be ignored for analysis

Correlation0.9490484453

idade_de_54_a_58
Highly correlated

This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis

Correlation0.9779514754

idade_emp_cat
Categorical

Distinct count6
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
1 a 5
157
5 a 10
144
> 20
92
Other values (3)
162
ValueCountFrequency (%) 
1 a 5 157 28.3%
 
5 a 10 144 25.9%
 
> 20 92 16.6%
 
<= 1 56 10.1%
 
10 a 15 55 9.9%
 
15 a 20 51 9.2%
 
Max length7
Mean length5.374774775
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

idade_empresa_anos
Numeric

Distinct count522
Unique (%)94.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean10.13924719
Minimum0.05205479452
Maximum47.51780822
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.05205479452
5-th percentile0.5575342466
Q12.924657534
Median6.709589041
Q315.49452055
95-th percentile30.3
Maximum47.51780822
Range47.46575342
Interquartile range12.56986301

Descriptive statistics

Standard deviation9.641625411
Coef of variation0.95092123
Kurtosis1.083164559
Mean10.13924719
MAD7.67673115
Skewness1.280516564
Sum5627.282192
Variance92.96094057
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0.05205479 1.70821918 8.00821918 8.01506849 13.64520548 32.32328767 47.51780822], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
8.010958904 4 0.7%
 
1.682191781 3 0.5%
 
1.583561644 3 0.5%
 
9.750684932 2 0.4%
 
1.15890411 2 0.4%
 
1.468493151 2 0.4%
 
6.416438356 2 0.4%
 
3.287671233 2 0.4%
 
1.597260274 2 0.4%
 
11.11232877 2 0.4%
 
Other values (512) 531 95.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0.05205479452 2 0.4%
 
0.1095890411 1 0.2%
 
0.1205479452 1 0.2%
 
0.1506849315 1 0.2%
 
0.1643835616 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
47.51780822 1 0.2%
 
46.76164384 1 0.2%
 
46.11506849 1 0.2%
 
43.18630137 1 0.2%
 
42.7260274 1 0.2%
 

idade_maxima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis

Correlation1

idade_maxima_socios
Numeric

Distinct count63
Unique (%)11.4%
Missing (%)34.8%
Missing (n)193
Infinite (%)0.0%
Infinite (n)0
Mean42.87292818
Minimum9
Maximum83
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum9
5-th percentile24
Q132
Median41
Q351
95-th percentile67.95
Maximum83
Range74
Interquartile range19

Descriptive statistics

Standard deviation13.48664618
Coef of variation0.3145725462
Kurtosis-0.1483653675
Mean42.87292818
MAD10.89212783
Skewness0.4970038169
Sum15520
Variance181.8896252
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
29 18 3.2%
 
37 13 2.3%
 
41 12 2.2%
 
34 12 2.2%
 
50 12 2.2%
 
40 11 2.0%
 
38 11 2.0%
 
42 11 2.0%
 
44 11 2.0%
 
49 10 1.8%
 
Other values (52) 241 43.4%
 
(Missing) 193 34.8%
 

Minimum 5 values

ValueCountFrequency (%) 
9 1 0.2%
 
18 2 0.4%
 
20 4 0.7%
 
21 2 0.4%
 
23 4 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
83 1 0.2%
 
82 1 0.2%
 
79 1 0.2%
 
78 1 0.2%
 
76 2 0.4%
 

idade_media_coligadas
Numeric

Distinct count63
Unique (%)11.4%
Missing (%)88.6%
Missing (n)492
Infinite (%)0.0%
Infinite (n)0
Mean162.9516377
Minimum4.066666667
Maximum484.3666667
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4.066666667
5-th percentile17.64666667
Q181.2
Median135.4666667
Q3225.9833333
95-th percentile373.8509524
Maximum484.3666667
Range480.3
Interquartile range144.7833333

Descriptive statistics

Standard deviation118.4303349
Coef of variation0.7267821088
Kurtosis0.2608933621
Mean162.9516377
MAD96.12434557
Skewness0.8460548977
Sum10265.95318
Variance14025.74422
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
27.73333333 2 0.4%
 
312.1 1 0.2%
 
86.5 1 0.2%
 
244.1979798 1 0.2%
 
93.73333333 1 0.2%
 
135.4666667 1 0.2%
 
476.0666667 1 0.2%
 
172.2 1 0.2%
 
194.3 1 0.2%
 
224.95 1 0.2%
 
Other values (52) 52 9.4%
 
(Missing) 492 88.6%
 

Minimum 5 values

ValueCountFrequency (%) 
4.066666667 1 0.2%
 
9.066666667 1 0.2%
 
10.16666667 1 0.2%
 
17.43333333 1 0.2%
 
19.56666667 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
484.3666667 1 0.2%
 
476.0666667 1 0.2%
 
426.4333333 1 0.2%
 
374.4714286 1 0.2%
 
368.2666667 1 0.2%
 

idade_media_coligadas_ativas
Highly correlated

This variable is highly correlated with idade_media_coligadas and should be ignored for analysis

Correlation1

idade_media_coligadas_baixadas
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

idade_media_socios
Highly correlated

This variable is highly correlated with idade_maxima_socios and should be ignored for analysis

Correlation0.9663386807

idade_minima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis

Correlation1

idade_minima_socios
Highly correlated

This variable is highly correlated with idade_media_socios and should be ignored for analysis

Correlation0.9672309258

max_faturamento_est_coligados
Highly correlated

This variable is highly correlated with faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.9753288607

max_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation0.9208848359

max_filiais_coligados
Numeric

Distinct count10
Unique (%)1.8%
Missing (%)97.3%
Missing (n)540
Infinite (%)0.0%
Infinite (n)0
Mean9.2
Minimum1
Maximum46
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median3
Q310
95-th percentile36.2
Maximum46
Range45
Interquartile range9

Descriptive statistics

Standard deviation13.27833897
Coef of variation1.443297714
Kurtosis3.786404955
Mean9.2
MAD9.626666667
Skewness2.058919419
Sum138
Variance176.3142857
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 5 0.9%
 
5 2 0.4%
 
3 2 0.4%
 
6 1 0.2%
 
46 1 0.2%
 
2 1 0.2%
 
32 1 0.2%
 
14 1 0.2%
 
17 1 0.2%
 
(Missing) 540 97.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 5 0.9%
 
2 1 0.2%
 
3 2 0.4%
 
5 2 0.4%
 
6 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
46 1 0.2%
 
32 1 0.2%
 
17 1 0.2%
 
14 1 0.2%
 
6 1 0.2%
 

max_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.9988162351

max_meses_servicos
Numeric

Distinct count87
Unique (%)15.7%
Missing (%)81.8%
Missing (n)454
Infinite (%)0.0%
Infinite (n)0
Mean72.98976898
Minimum5.8
Maximum309.3333333
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum5.8
5-th percentile10
Q125.23333333
Median54.7
Q393.26666667
95-th percentile198.7666667
Maximum309.3333333
Range303.5333333
Interquartile range68.03333333

Descriptive statistics

Standard deviation61.44349522
Coef of variation0.8418096959
Kurtosis2.367120623
Mean72.98976898
MAD46.91584485
Skewness1.488274524
Sum7371.966667
Variance3775.303105
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
89.2 4 0.7%
 
21.13333333 3 0.5%
 
25.23333333 2 0.4%
 
93.26666667 2 0.4%
 
23.2 2 0.4%
 
18.13333333 2 0.4%
 
17.13333333 2 0.4%
 
49.6 2 0.4%
 
81.06666667 2 0.4%
 
43.53333333 2 0.4%
 
Other values (76) 78 14.1%
 
(Missing) 454 81.8%
 

Minimum 5 values

ValueCountFrequency (%) 
5.8 1 0.2%
 
5.966666667 1 0.2%
 
6.966666667 1 0.2%
 
9.366666667 1 0.2%
 
9.9 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
309.3333333 1 0.2%
 
253.5 1 0.2%
 
252.4333333 1 0.2%
 
234.2666667 1 0.2%
 
200.7666667 1 0.2%
 

max_meses_servicos_all
Numeric

Distinct count120
Unique (%)21.6%
Missing (%)76.4%
Missing (n)424
Infinite (%)0.0%
Infinite (n)0
Mean103.3498728
Minimum1.033333333
Maximum5014.966667
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.033333333
5-th percentile5.883333333
Q123.23333333
Median46.66666667
Q389.2
95-th percentile196.2166667
Maximum5014.966667
Range5013.933333
Interquartile range65.96666667

Descriptive statistics

Standard deviation436.3619417
Coef of variation4.222181702
Kurtosis126.2351103
Mean103.3498728
MAD98.03210769
Skewness11.13790553
Sum13538.83333
Variance190411.7442
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
89.2 4 0.7%
 
49.6 2 0.4%
 
23.2 2 0.4%
 
52.76666667 2 0.4%
 
81.06666667 2 0.4%
 
43.53333333 2 0.4%
 
17.13333333 2 0.4%
 
93.26666667 2 0.4%
 
28.43333333 2 0.4%
 
95.23333333 2 0.4%
 
Other values (109) 109 19.6%
 
(Missing) 424 76.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1.033333333 1 0.2%
 
2.033333333 1 0.2%
 
3.433333333 1 0.2%
 
4 1 0.2%
 
4.6 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
5014.966667 1 0.2%
 
309.3333333 1 0.2%
 
252.4333333 1 0.2%
 
234.2666667 1 0.2%
 
213.4 1 0.2%
 

max_vl_folha_coligados
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation0.9432797848

max_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.9830355726

media_faturamento_est_coligados
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.9460011571

media_faturamento_est_coligados_gp
Numeric

Distinct count40
Unique (%)7.2%
Missing (%)88.8%
Missing (n)493
Infinite (%)0.0%
Infinite (n)0
Mean6347711.473
Minimum61819.19922
Maximum240723968
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum61819.19922
5-th percentile210000
Q1210000
Median435000
Q31067895.818
95-th percentile9344487.25
Maximum240723968
Range240662148.8
Interquartile range857895.8177

Descriptive statistics

Standard deviation31643431.39
Coef of variation4.98501413
Kurtosis51.56392603
Mean6347711.473
MAD10327019.31
Skewness7.011777806
Sum393558111.3
Variance1.00130675e+15
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=40)
ValueCountFrequency (%) 
210000 19 3.4%
 
370915.1875 3 0.5%
 
228638.3984 2 0.4%
 
930000 2 0.4%
 
556372.8125 2 0.4%
 
61819.19922 1 0.2%
 
1470000 1 0.2%
 
26555480.93 1 0.2%
 
420000 1 0.2%
 
5811005 1 0.2%
 
Other values (29) 29 5.2%
 
(Missing) 493 88.8%
 

Minimum 5 values

ValueCountFrequency (%) 
61819.19922 1 0.2%
 
185457.5938 1 0.2%
 
206064 1 0.2%
 
210000 19 3.4%
 
228638.3984 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
240723968 1 0.2%
 
68718535.64 1 0.2%
 
26555480.93 1 0.2%
 
9530460 1 0.2%
 
5811005 1 0.2%
 

media_filiais_coligados
Highly correlated

This variable is highly correlated with max_filiais_coligados and should be ignored for analysis

Correlation0.984817247

media_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with media_filiais_coligados and should be ignored for analysis

Correlation0.9290150933

media_meses_servicos
Numeric

Distinct count97
Unique (%)17.5%
Missing (%)81.8%
Missing (n)454
Infinite (%)0.0%
Infinite (n)0
Mean49.92900583
Minimum5.406666667
Maximum228.1555556
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum5.406666667
5-th percentile6.416666667
Q122.32307692
Median41.96666667
Q365.91666667
95-th percentile131.6916667
Maximum228.1555556
Range222.7488889
Interquartile range43.59358974

Descriptive statistics

Standard deviation40.96894942
Coef of variation0.8205440653
Kurtosis4.839175601
Mean49.92900583
MAD28.94381254
Skewness1.924815809
Sum5042.829589
Variance1678.454816
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
18.13333333 2 0.4%
 
23.2 2 0.4%
 
66.83333333 2 0.4%
 
23.53333333 2 0.4%
 
49.6 2 0.4%
 
12.74444444 1 0.2%
 
71.13333333 1 0.2%
 
14.4525641 1 0.2%
 
11.53333333 1 0.2%
 
22.1 1 0.2%
 
Other values (86) 86 15.5%
 
(Missing) 454 81.8%
 

Minimum 5 values

ValueCountFrequency (%) 
5.406666667 1 0.2%
 
5.716666667 1 0.2%
 
5.955555556 1 0.2%
 
6.15 1 0.2%
 
6.333333333 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
228.1555556 1 0.2%
 
199.7666667 1 0.2%
 
176.9333333 1 0.2%
 
148 1 0.2%
 
142.9 1 0.2%
 

media_meses_servicos_all
Highly correlated

This variable is highly correlated with max_meses_servicos_all and should be ignored for analysis

Correlation0.9651590156

media_vl_folha_coligados
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis

Correlation0.9023282866

media_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with media_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.9956423815

meses_ultima_contratacaco
Numeric

Distinct count103
Unique (%)18.6%
Missing (%)76.4%
Missing (n)424
Infinite (%)0.0%
Infinite (n)0
Mean35.05928753
Minimum2.166666667
Maximum153.1
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.166666667
5-th percentile2.933333333
Q18.033333333
Median23.2
Q354.66666667
95-th percentile92.75
Maximum153.1
Range150.9333333
Interquartile range46.63333333

Descriptive statistics

Standard deviation31.5211692
Coef of variation0.8990818529
Kurtosis1.30509277
Mean35.05928753
MAD25.68343725
Skewness1.182480184
Sum4592.766667
Variance993.5841075
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
2.933333333 6 1.1%
 
6.966666667 4 0.7%
 
21.13333333 3 0.5%
 
22.13333333 3 0.5%
 
25.23333333 3 0.5%
 
23.2 3 0.5%
 
4.966666667 3 0.5%
 
5.966666667 2 0.4%
 
58.66666667 2 0.4%
 
18.13333333 2 0.4%
 
Other values (92) 100 18.0%
 
(Missing) 424 76.4%
 

Minimum 5 values

ValueCountFrequency (%) 
2.166666667 1 0.2%
 
2.2 1 0.2%
 
2.233333333 1 0.2%
 
2.533333333 1 0.2%
 
2.933333333 6 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
153.1 1 0.2%
 
142.9 1 0.2%
 
112.3333333 1 0.2%
 
104.0333333 1 0.2%
 
102.3666667 1 0.2%
 

min_faturamento_est_coligados
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.9401087019

min_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados and should be ignored for analysis

Correlation0.9857654776

min_filiais_coligados
Highly correlated

This variable is highly correlated with media_vl_folha_coligados_gp and should be ignored for analysis

Correlation0.9113088103

min_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.9974669262

min_meses_servicos
Numeric

Distinct count79
Unique (%)14.2%
Missing (%)81.8%
Missing (n)454
Infinite (%)0.0%
Infinite (n)0
Mean33.61551155
Minimum2.166666667
Maximum192.6333333
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.166666667
5-th percentile2.933333333
Q15.966666667
Median22.13333333
Q348.56666667
95-th percentile104.0333333
Maximum192.6333333
Range190.4666667
Interquartile range42.6

Descriptive statistics

Standard deviation37.4105082
Coef of variation1.112894211
Kurtosis4.072852971
Mean33.61551155
MAD27.72425579
Skewness1.910373555
Sum3395.166667
Variance1399.546124
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
2.933333333 6 1.1%
 
23.2 4 0.7%
 
6.966666667 4 0.7%
 
4.966666667 3 0.5%
 
22.13333333 2 0.4%
 
49.6 2 0.4%
 
25.23333333 2 0.4%
 
38.43333333 2 0.4%
 
3.833333333 2 0.4%
 
61.76666667 2 0.4%
 
Other values (68) 72 13.0%
 
(Missing) 454 81.8%
 

Minimum 5 values

ValueCountFrequency (%) 
2.166666667 1 0.2%
 
2.2 1 0.2%
 
2.233333333 1 0.2%
 
2.533333333 1 0.2%
 
2.933333333 6 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
192.6333333 1 0.2%
 
153.1 1 0.2%
 
148 1 0.2%
 
142.9 1 0.2%
 
117.5666667 1 0.2%
 

min_meses_servicos_all
Numeric

Distinct count101
Unique (%)18.2%
Missing (%)76.4%
Missing (n)424
Infinite (%)0.0%
Infinite (n)0
Mean13.21882952
Minimum-0.7
Maximum142.9
Zeros (%)0.9%
Mini histogram

Quantile statistics

Minimum-0.7
5-th percentile0
Q11.033333333
Median5.033333333
Q317.28333333
95-th percentile53.36666667
Maximum142.9
Range143.6
Interquartile range16.25

Descriptive statistics

Standard deviation20.45002752
Coef of variation1.547037693
Kurtosis14.69860143
Mean13.21882952
MAD13.28032554
Skewness3.282660463
Sum1731.666667
Variance418.2036256
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 8 1.4%
 
0 5 0.9%
 
3.066666667 4 0.7%
 
1.033333333 3 0.5%
 
2.033333333 3 0.5%
 
6.966666667 2 0.4%
 
6.033333333 2 0.4%
 
0.7 2 0.4%
 
2.933333333 2 0.4%
 
8.133333333 2 0.4%
 
Other values (90) 98 17.7%
 
(Missing) 424 76.4%
 

Minimum 5 values

ValueCountFrequency (%) 
-0.7 1 0.2%
 
-0.4666666667 1 0.2%
 
-0.2333333333 1 0.2%
 
-0.06666666667 2 0.4%
 
0 5 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
142.9 1 0.2%
 
104.0333333 1 0.2%
 
69 1 0.2%
 
64.83333333 1 0.2%
 
54.73333333 1 0.2%
 

min_vl_folha_coligados
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados and should be ignored for analysis

Correlation0.9115581462

min_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with min_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.9997894656

natureza_juridica_macro
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
OUTROS
447
ENTIDADES EMPRESARIAIS
108
ValueCountFrequency (%) 
OUTROS 447 80.5%
 
ENTIDADES EMPRESARIAIS 108 19.5%
 
Max length22
Mean length9.113513514
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_divisao
Categorical

Distinct count8
Unique (%)1.4%
Missing (%)0.0%
Missing (n)0
COMERCIO VAREJISTA
496
FABRICACAO DE PRODUTOS ALIMENTICIOS
 
16
CONFECCAO DE ARTIGOS DO VESTUARIO E ACESSORIOS
 
9
Other values (5)
 
34
ValueCountFrequency (%) 
COMERCIO VAREJISTA 496 89.4%
 
FABRICACAO DE PRODUTOS ALIMENTICIOS 16 2.9%
 
CONFECCAO DE ARTIGOS DO VESTUARIO E ACESSORIOS 9 1.6%
 
FABRICACAO DE PRODUTOS DE MADEIRA 9 1.6%
 
FABRICACAO DE MOVEIS 9 1.6%
 
FABRICACAO DE PRODUTOS DIVERSOS 8 1.4%
 
MANUTENCAO REPARACAO E INSTALACAO DE MAQUINAS E EQUIPAMENTOS 7 1.3%
 
FABRICACAO DE BEBIDAS 1 0.2%
 
Max length60
Mean length19.94234234
Min length18
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_meso_regiao
Categorical

Distinct count20
Unique (%)3.6%
Missing (%)11.5%
Missing (n)64
CENTRO AMAZONENSE
78
LESTE POTIGUAR
77
NORTE MARANHENSE
65
Other values (16)
271
(Missing)
64
ValueCountFrequency (%) 
CENTRO AMAZONENSE 78 14.1%
 
LESTE POTIGUAR 77 13.9%
 
NORTE MARANHENSE 65 11.7%
 
CENTRO NORTE PIAUIENSE 55 9.9%
 
OESTE MARANHENSE 36 6.5%
 
LESTE MARANHENSE 25 4.5%
 
CENTRO MARANHENSE 21 3.8%
 
VALE DO ACRE 20 3.6%
 
OESTE POTIGUAR 18 3.2%
 
SUDESTE PIAUIENSE 17 3.1%
 
Other values (9) 79 14.2%
 
(Missing) 64 11.5%
 
Max length22
Mean length14.80540541
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_micro_regiao
Categorical

Distinct count67
Unique (%)12.1%
Missing (%)11.5%
Missing (n)64
MANAUS
65
NATAL
 
58
AGLOMERACAO URBANA DE SAO LUIS
 
48
Other values (63)
320
(Missing)
 
64
ValueCountFrequency (%) 
MANAUS 65 11.7%
 
NATAL 58 10.5%
 
AGLOMERACAO URBANA DE SAO LUIS 48 8.6%
 
TERESINA 41 7.4%
 
IMPERATRIZ 20 3.6%
 
RIO BRANCO 15 2.7%
 
PINDARE 11 2.0%
 
LITORAL SUL 10 1.8%
 
ALTO MEDIO CANINDE 9 1.6%
 
MEDIO MEARIM 9 1.6%
 
Other values (56) 205 36.9%
 
(Missing) 64 11.5%
 
Max length33
Mean length11.13153153
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_segmento
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS
496
INDUSTRIAS DE TRANSFORMACAO
 
59
ValueCountFrequency (%) 
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 496 89.4%
 
INDUSTRIAS DE TRANSFORMACAO 59 10.6%
 
Max length58
Mean length54.7045045
Min length27
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nu_meses_rescencia
Numeric

Distinct count24
Unique (%)4.3%
Missing (%)8.5%
Missing (n)47
Infinite (%)0.0%
Infinite (n)0
Mean24.77165354
Minimum7
Maximum54
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum7
5-th percentile9
Q122
Median23
Q325
95-th percentile48
Maximum54
Range47
Interquartile range3

Descriptive statistics

Standard deviation9.969728522
Coef of variation0.402465201
Kurtosis1.800586709
Mean24.77165354
MAD6.057691115
Skewness1.222048203
Sum12584
Variance99.39548681
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%) 
23 124 22.3%
 
22 107 19.3%
 
24 51 9.2%
 
48 35 6.3%
 
25 35 6.3%
 
26 28 5.0%
 
21 22 4.0%
 
27 16 2.9%
 
9 13 2.3%
 
10 13 2.3%
 
Other values (13) 64 11.5%
 
(Missing) 47 8.5%
 

Minimum 5 values

ValueCountFrequency (%) 
7 10 1.8%
 
8 11 2.0%
 
9 13 2.3%
 
10 13 2.3%
 
11 5 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
54 3 0.5%
 
52 1 0.2%
 
50 11 2.0%
 
49 4 0.7%
 
48 35 6.3%
 

percent_func_genero_fem
Numeric

Distinct count31
Unique (%)5.6%
Missing (%)81.8%
Missing (n)454
Infinite (%)0.0%
Infinite (n)0
Mean54.43534653
Minimum0
Maximum100
Zeros (%)4.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q119.23
Median53.85
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range80.77

Descriptive statistics

Standard deviation38.79162661
Coef of variation0.712618346
Kurtosis-1.444618072
Mean54.43534653
MAD33.76817175
Skewness-0.1589297694
Sum5497.97
Variance1504.790295
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%) 
100 32 5.8%
 
0 22 4.0%
 
50 11 2.0%
 
66.67 5 0.9%
 
33.33 4 0.7%
 
60 2 0.4%
 
75 2 0.4%
 
25 1 0.2%
 
62.5 1 0.2%
 
37.5 1 0.2%
 
Other values (20) 20 3.6%
 
(Missing) 454 81.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 22 4.0%
 
4.76 1 0.2%
 
14.29 1 0.2%
 
15.71 1 0.2%
 
19.23 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
100 32 5.8%
 
85.71 1 0.2%
 
80 1 0.2%
 
77.78 1 0.2%
 
75 2 0.4%
 

percent_func_genero_masc
Numeric

Distinct count31
Unique (%)5.6%
Missing (%)81.8%
Missing (n)454
Infinite (%)0.0%
Infinite (n)0
Mean45.56465347
Minimum0
Maximum100
Zeros (%)5.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median46.15
Q380.77
95-th percentile100
Maximum100
Range100
Interquartile range80.77

Descriptive statistics

Standard deviation38.79162661
Coef of variation0.851353487
Kurtosis-1.444618072
Mean45.56465347
MAD33.76817175
Skewness0.1589297694
Sum4602.03
Variance1504.790295
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%) 
0 32 5.8%
 
100 22 4.0%
 
50 11 2.0%
 
33.33 5 0.9%
 
66.67 4 0.7%
 
40 2 0.4%
 
25 2 0.4%
 
14.29 1 0.2%
 
37.5 1 0.2%
 
62.5 1 0.2%
 
Other values (20) 20 3.6%
 
(Missing) 454 81.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 32 5.8%
 
14.29 1 0.2%
 
20 1 0.2%
 
22.22 1 0.2%
 
25 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
100 22 4.0%
 
95.24 1 0.2%
 
85.71 1 0.2%
 
84.29 1 0.2%
 
80.77 1 0.2%
 

qt_admitidos
Numeric

Distinct count41
Unique (%)7.4%
Missing (%)76.4%
Missing (n)424
Infinite (%)0.0%
Infinite (n)0
Mean14.3740458
Minimum1
Maximum203
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11.5
Median5
Q313.5
95-th percentile49.5
Maximum203
Range202
Interquartile range12

Descriptive statistics

Standard deviation26.95590013
Coef of variation1.875317534
Kurtosis25.18314462
Mean14.3740458
MAD15.13023717
Skewness4.481608458
Sum1883
Variance726.620552
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=41)
ValueCountFrequency (%) 
1 33 5.9%
 
2 14 2.5%
 
4 12 2.2%
 
6 7 1.3%
 
3 5 0.9%
 
8 5 0.9%
 
13 4 0.7%
 
9 4 0.7%
 
7 4 0.7%
 
10 4 0.7%
 
Other values (30) 39 7.0%
 
(Missing) 424 76.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 33 5.9%
 
2 14 2.5%
 
3 5 0.9%
 
4 12 2.2%
 
5 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
203 1 0.2%
 
164 1 0.2%
 
100 1 0.2%
 
69 1 0.2%
 
65 1 0.2%
 

qt_admitidos_12meses
Numeric

Distinct count12
Unique (%)2.2%
Missing (%)76.4%
Missing (n)424
Infinite (%)0.0%
Infinite (n)0
Mean1.022900763
Minimum0
Maximum15
Zeros (%)16.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile5.5
Maximum15
Range15
Interquartile range1

Descriptive statistics

Standard deviation2.358179379
Coef of variation2.305384318
Kurtosis16.49629146
Mean1.022900763
MAD1.395839403
Skewness3.707068821
Sum134
Variance5.561009982
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%) 
0 89 16.0%
 
1 17 3.1%
 
2 7 1.3%
 
3 6 1.1%
 
4 4 0.7%
 
7 2 0.4%
 
6 2 0.4%
 
14 1 0.2%
 
9 1 0.2%
 
15 1 0.2%
 
(Missing) 424 76.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 89 16.0%
 
1 17 3.1%
 
2 7 1.3%
 
3 6 1.1%
 
4 4 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
15 1 0.2%
 
14 1 0.2%
 
9 1 0.2%
 
7 2 0.4%
 
6 2 0.4%
 

qt_alteracao_socio_180d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_365d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_90d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_total
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_art
Highly correlated

This variable is highly correlated with qt_admitidos and should be ignored for analysis

Correlation1

qt_coligadas
Highly correlated

This variable is highly correlated with min_filiais_coligados and should be ignored for analysis

Correlation0.9682511623

qt_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation0.9974819746

qt_coligados_agropecuaria
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)88.6%
Missing (n)492
0
 
62
1
 
1
(Missing)
492
ValueCountFrequency (%) 
0 62 11.2%
 
1 1 0.2%
 
(Missing) 492 88.6%
 

qt_coligados_atividade_alto
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)88.6%
Missing (n)492
0
 
63
(Missing)
492
ValueCountFrequency (%) 
0 63 11.4%
 
(Missing) 492 88.6%
 

qt_coligados_atividade_baixo
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)88.6%
Missing (n)492
0
 
63
(Missing)
492
ValueCountFrequency (%) 
0 63 11.4%
 
(Missing) 492 88.6%
 

qt_coligados_atividade_inativo
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)88.6%
Missing (n)492
0
 
63
(Missing)
492
ValueCountFrequency (%) 
0 63 11.4%
 
(Missing) 492 88.6%
 

qt_coligados_atividade_medio
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)88.6%
Missing (n)492
0
 
63
(Missing)
492
ValueCountFrequency (%) 
0 63 11.4%
 
(Missing) 492 88.6%
 

qt_coligados_atividade_mt_baixo
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)88.6%
Missing (n)492
0
 
63
(Missing)
492
ValueCountFrequency (%) 
0 63 11.4%
 
(Missing) 492 88.6%
 

qt_coligados_ativo
Numeric

Distinct count13
Unique (%)2.3%
Missing (%)88.6%
Missing (n)492
Infinite (%)0.0%
Infinite (n)0
Mean3.793650794
Minimum0
Maximum42
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q11
Median2
Q33
95-th percentile18.9
Maximum42
Range42
Interquartile range2

Descriptive statistics

Standard deviation7.304790143
Coef of variation1.925530456
Kurtosis15.98976811
Mean3.793650794
MAD3.786344167
Skewness3.911453634
Sum239
Variance53.35995904
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%) 
1 30 5.4%
 
2 15 2.7%
 
3 6 1.1%
 
5 3 0.5%
 
9 2 0.4%
 
42 1 0.2%
 
0 1 0.2%
 
6 1 0.2%
 
4 1 0.2%
 
20 1 0.2%
 
Other values (2) 2 0.4%
 
(Missing) 492 88.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
1 30 5.4%
 
2 15 2.7%
 
3 6 1.1%
 
4 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
42 1 0.2%
 
33 1 0.2%
 
23 1 0.2%
 
20 1 0.2%
 
9 2 0.4%
 

qt_coligados_baixada
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)88.6%
Missing (n)492
0
 
63
(Missing)
492
ValueCountFrequency (%) 
0 63 11.4%
 
(Missing) 492 88.6%
 

qt_coligados_ccivil
Highly correlated

This variable is highly correlated with qt_art and should be ignored for analysis

Correlation1

qt_coligados_centro
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation0.9142772641

qt_coligados_comercio
Numeric

Distinct count11
Unique (%)2.0%
Missing (%)88.6%
Missing (n)492
Infinite (%)0.0%
Infinite (n)0
Mean2.444444444
Minimum0
Maximum42
Zeros (%)3.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32
95-th percentile8.6
Maximum42
Range42
Interquartile range2

Descriptive statistics

Standard deviation6.341816616
Coef of variation2.594379525
Kurtosis26.42177439
Mean2.444444444
MAD2.888888889
Skewness4.879665149
Sum154
Variance40.21863799
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%) 
1 25 4.5%
 
0 21 3.8%
 
2 8 1.4%
 
5 2 0.4%
 
3 2 0.4%
 
42 1 0.2%
 
4 1 0.2%
 
9 1 0.2%
 
20 1 0.2%
 
22 1 0.2%
 
(Missing) 492 88.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 21 3.8%
 
1 25 4.5%
 
2 8 1.4%
 
3 2 0.4%
 
4 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
42 1 0.2%
 
22 1 0.2%
 
20 1 0.2%
 
9 1 0.2%
 
5 2 0.4%
 

qt_coligados_epp
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)88.6%
Missing (n)492
0
 
63
(Missing)
492
ValueCountFrequency (%) 
0 63 11.4%
 
(Missing) 492 88.6%
 

qt_coligados_exterior
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)88.6%
Missing (n)492
0
 
63
(Missing)
492
ValueCountFrequency (%) 
0 63 11.4%
 
(Missing) 492 88.6%
 

qt_coligados_inapta
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)88.6%
Missing (n)492
0
 
62
1
 
1
(Missing)
492
ValueCountFrequency (%) 
0 62 11.2%
 
1 1 0.2%
 
(Missing) 492 88.6%
 

qt_coligados_industria
Highly correlated

This variable is highly correlated with qt_coligados_ccivil and should be ignored for analysis

Correlation0.9011165757

qt_coligados_ltda
Highly correlated

This variable is highly correlated with qt_coligados_centro and should be ignored for analysis

Correlation1

qt_coligados_matriz
Highly correlated

This variable is highly correlated with qt_coligados and should be ignored for analysis

Correlation0.991544335

qt_coligados_me
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)88.6%
Missing (n)492
0
 
63
(Missing)
492
ValueCountFrequency (%) 
0 63 11.4%
 
(Missing) 492 88.6%
 

qt_coligados_mei
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)88.6%
Missing (n)492
0
 
63
(Missing)
492
ValueCountFrequency (%) 
0 63 11.4%
 
(Missing) 492 88.6%
 

qt_coligados_nordeste
Highly correlated

This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis

Correlation0.9006896596

qt_coligados_norte
Highly correlated

This variable is highly correlated with qt_art and should be ignored for analysis

Correlation1

qt_coligados_nula
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)88.6%
Missing (n)492
0
 
63
(Missing)
492
ValueCountFrequency (%) 
0 63 11.4%
 
(Missing) 492 88.6%
 

qt_coligados_sa
Highly correlated

This variable is highly correlated with qt_coligados_industria and should be ignored for analysis

Correlation0.9802385571

qt_coligados_serviço
Highly correlated

This variable is highly correlated with max_vl_folha_coligados and should be ignored for analysis

Correlation0.9134551877

qt_coligados_sudeste
Highly correlated

This variable is highly correlated with qt_coligados_ltda and should be ignored for analysis

Correlation0.9443641162

qt_coligados_sul
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)88.6%
Missing (n)492
0
 
63
(Missing)
492
ValueCountFrequency (%) 
0 63 11.4%
 
(Missing) 492 88.6%
 

qt_coligados_suspensa
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)88.6%
Missing (n)492
0
 
63
(Missing)
492
ValueCountFrequency (%) 
0 63 11.4%
 
(Missing) 492 88.6%
 

qt_desligados
Highly correlated

This variable is highly correlated with qt_art and should be ignored for analysis

Correlation1

qt_desligados_12meses
Highly correlated

This variable is highly correlated with qt_art and should be ignored for analysis

Correlation1

qt_ex_funcionarios
Highly correlated

This variable is highly correlated with qt_desligados and should be ignored for analysis

Correlation0.9999417874

qt_filiais
Highly correlated

This variable is highly correlated with qt_coligados_sa and should be ignored for analysis

Correlation0.9757969605

qt_funcionarios
Highly correlated

This variable is highly correlated with idade_de_49_a_53 and should be ignored for analysis

Correlation0.9326400842

qt_funcionarios_12meses
Highly correlated

This variable is highly correlated with qt_funcionarios and should be ignored for analysis

Correlation0.9757958364

qt_funcionarios_24meses
Highly correlated

This variable is highly correlated with qt_admitidos and should be ignored for analysis

Correlation0.9220046051

qt_funcionarios_coligados
Highly correlated

This variable is highly correlated with qt_filiais and should be ignored for analysis

Correlation0.9495362911

qt_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados and should be ignored for analysis

Correlation0.971940039

qt_funcionarios_grupo
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.9157758137

qt_ramos_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_grupo and should be ignored for analysis

Correlation0.966877865

qt_regioes_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation0.9142772641

qt_socios
Numeric

Distinct count7
Unique (%)1.3%
Missing (%)26.5%
Missing (n)147
Infinite (%)0.0%
Infinite (n)0
Mean1.279411765
Minimum1
Maximum9
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile2
Maximum9
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.6541251802
Coef of variation0.5112702558
Kurtosis50.12274312
Mean1.279411765
MAD0.4314446367
Skewness5.302991985
Sum522
Variance0.4278797514
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
1 315 56.8%
 
2 81 14.6%
 
3 9 1.6%
 
5 1 0.2%
 
9 1 0.2%
 
4 1 0.2%
 
(Missing) 147 26.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 315 56.8%
 
2 81 14.6%
 
3 9 1.6%
 
4 1 0.2%
 
5 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
9 1 0.2%
 
5 1 0.2%
 
4 1 0.2%
 
3 9 1.6%
 
2 81 14.6%
 

qt_socios_coligados
Highly correlated

This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis

Correlation0.9824935146

qt_socios_feminino
Categorical

Distinct count3
Unique (%)0.5%
Missing (%)65.8%
Missing (n)365
1
179
2
 
11
(Missing)
365
ValueCountFrequency (%) 
1 179 32.3%
 
2 11 2.0%
 
(Missing) 365 65.8%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_socios_masculino
Highly correlated

This variable is highly correlated with qt_art and should be ignored for analysis

Correlation1

qt_socios_pep
Highly correlated

This variable is highly correlated with qt_socios_masculino and should be ignored for analysis

Correlation1

qt_socios_pf
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation1

qt_socios_pj
Categorical

Distinct count4
Unique (%)0.7%
Missing (%)26.5%
Missing (n)147
0
406
2
 
1
1
 
1
(Missing)
147
ValueCountFrequency (%) 
0 406 73.2%
 
2 1 0.2%
 
1 1 0.2%
 
(Missing) 147 26.5%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_socios_pj_ativos
Highly correlated

This variable is highly correlated with qt_socios_pj and should be ignored for analysis

Correlation1

qt_socios_pj_baixados
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)99.6%
Missing (n)553
0
 
2
(Missing)
553
ValueCountFrequency (%) 
0 2 0.4%
 
(Missing) 553 99.6%
 

qt_socios_pj_inaptos
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)99.6%
Missing (n)553
0
 
2
(Missing)
553
ValueCountFrequency (%) 
0 2 0.4%
 
(Missing) 553 99.6%
 

qt_socios_pj_nulos
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)99.6%
Missing (n)553
0
 
2
(Missing)
553
ValueCountFrequency (%) 
0 2 0.4%
 
(Missing) 553 99.6%
 

qt_socios_pj_suspensos
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)99.6%
Missing (n)553
0
 
2
(Missing)
553
ValueCountFrequency (%) 
0 2 0.4%
 
(Missing) 553 99.6%
 

qt_socios_st_regular
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation1

qt_socios_st_suspensa
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)98.7%
Missing (n)548
1
 
7
(Missing)
548
ValueCountFrequency (%) 
1 7 1.3%
 
(Missing) 548 98.7%
 

qt_ufs_coligados
Highly correlated

This variable is highly correlated with qt_socios_pj_ativos and should be ignored for analysis

Correlation1

setor
Categorical

Distinct count3
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
COMERCIO
496
INDUSTRIA
 
52
SERVIÇO
 
7
ValueCountFrequency (%) 
COMERCIO 496 89.4%
 
INDUSTRIA 52 9.4%
 
SERVIÇO 7 1.3%
 
Max length9
Mean length8.081081081
Min length7
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sg_uf
Categorical

Distinct count6
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
MA
157
RN
116
PI
103
Other values (3)
179
ValueCountFrequency (%) 
MA 157 28.3%
 
RN 116 20.9%
 
PI 103 18.6%
 
AM 94 16.9%
 
RO 64 11.5%
 
AC 21 3.8%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sg_uf_matriz
Categorical

Distinct count7
Unique (%)1.3%
Missing (%)0.0%
Missing (n)0
MA
156
RN
116
PI
103
Other values (4)
180
ValueCountFrequency (%) 
MA 156 28.1%
 
RN 116 20.9%
 
PI 103 18.6%
 
AM 93 16.8%
 
RO 64 11.5%
 
AC 22 4.0%
 
CE 1 0.2%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sum_faturamento_estimado_coligadas
Highly correlated

This variable is highly correlated with qt_regioes_coligados and should be ignored for analysis

Correlation0.9794843167

total
Highly correlated

This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis

Correlation0.9743791866

total_filiais_coligados
Numeric

Distinct count12
Unique (%)2.2%
Missing (%)97.3%
Missing (n)540
Infinite (%)0.0%
Infinite (n)0
Mean14.53333333
Minimum1
Maximum46
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median5
Q325.5
95-th percentile41.8
Maximum46
Range45
Interquartile range24.5

Descriptive statistics

Standard deviation16.32205636
Coef of variation1.123077272
Kurtosis-0.7883560931
Mean14.53333333
MAD13.70666667
Skewness0.8762728433
Sum218
Variance266.4095238
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%) 
1 5 0.9%
 
36 1 0.2%
 
46 1 0.2%
 
2 1 0.2%
 
5 1 0.2%
 
32 1 0.2%
 
19 1 0.2%
 
13 1 0.2%
 
3 1 0.2%
 
40 1 0.2%
 
(Missing) 540 97.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 5 0.9%
 
2 1 0.2%
 
3 1 0.2%
 
5 1 0.2%
 
13 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
46 1 0.2%
 
40 1 0.2%
 
36 1 0.2%
 
32 1 0.2%
 
19 1 0.2%
 

tx_crescimento_12meses
Numeric

Distinct count26
Unique (%)4.7%
Missing (%)82.5%
Missing (n)458
Infinite (%)0.0%
Infinite (n)0
Mean-0.13232472
Minimum-100
Maximum200
Zeros (%)11.4%
Mini histogram

Quantile statistics

Minimum-100
5-th percentile-66.9047619
Q10
Median0
Q30
95-th percentile34
Maximum200
Range300
Interquartile range0

Descriptive statistics

Standard deviation40.32431378
Coef of variation-304.7375713
Kurtosis12.55770928
Mean-0.13232472
MAD16.53372542
Skewness2.337460584
Sum-12.83549784
Variance1626.050282
Memory size4.4 KiB
Histogram
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%) 
0 63 11.4%
 
-50 3 0.5%
 
-16.66666667 3 0.5%
 
-6.666666667 3 0.5%
 
-100 2 0.4%
 
14.28571429 2 0.4%
 
100 2 0.4%
 
200 2 0.4%
 
-33.33333333 1 0.2%
 
-71.42857143 1 0.2%
 
Other values (15) 15 2.7%
 
(Missing) 458 82.5%
 

Minimum 5 values

ValueCountFrequency (%) 
-100 2 0.4%
 
-72.72727273 1 0.2%
 
-71.42857143 1 0.2%
 
-67.85714286 1 0.2%
 
-66.66666667 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
200 2 0.4%
 
100 2 0.4%
 
50 1 0.2%
 
30 1 0.2%
 
25 1 0.2%
 

tx_crescimento_24meses
Highly correlated

This variable is highly correlated with min_vl_folha_coligados_gp and should be ignored for analysis

Correlation0.9675760839

tx_rotatividade
Highly correlated

This variable is highly correlated with qt_art and should be ignored for analysis

Correlation1

Unnamed_0
Highly correlated

This variable is highly correlated with qt_socios_pj_ativos and should be ignored for analysis

Correlation1

vl_faturamento_estimado_aux
Highly correlated

This variable is highly correlated with qt_socios_pj_ativos and should be ignored for analysis

Correlation1

vl_faturamento_estimado_grupo_aux
Highly correlated

This variable is highly correlated with qt_socios_pj_ativos and should be ignored for analysis

Correlation1

vl_folha_coligados
Highly correlated

This variable is highly correlated with vl_faturamento_estimado_grupo_aux and should be ignored for analysis

Correlation0.9801776077

vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with vl_folha_coligados and should be ignored for analysis

Correlation0.9769040844

vl_frota
Highly correlated

This variable is highly correlated with total_filiais_coligados and should be ignored for analysis

Correlation1

vl_idade_maxima_socios_pj
Highly correlated

This variable is highly correlated with vl_faturamento_estimado_grupo_aux and should be ignored for analysis

Correlation1

vl_idade_media_socios_pj
Highly correlated

This variable is highly correlated with nu_meses_rescencia and should be ignored for analysis

Correlation1

vl_idade_minima_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_media_socios_pj and should be ignored for analysis

Correlation1

vl_potenc_cons_oleo_gas
Highly correlated

This variable is highly correlated with tx_crescimento_24meses and should be ignored for analysis

Correlation1

vl_total_tancagem
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_tancagem_grupo
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_antt
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_antt_grupo
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_leves
Highly correlated

This variable is highly correlated with total_filiais_coligados and should be ignored for analysis

Correlation1

vl_total_veiculos_leves_grupo
Highly correlated

This variable is highly correlated with vl_idade_maxima_socios_pj and should be ignored for analysis

Correlation1

vl_total_veiculos_pesados
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation1

vl_total_veiculos_pesados_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_leves_grupo and should be ignored for analysis

Correlation0.9945105446

Correlations

Missing values

Sample

First rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadeUnnamed_0vl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
0NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXACOMERCIO VAREJISTASEM INFORMACAOCINZA2018-03-06379.96NaNNaNFalseFalseFalseFalseTrueFalseTrueNaNNaNFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaNdabe79bec87c88ae04e869bf6bd321ee5e1893cecf6625...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.646575NaN45.0NaNNaNNaN45.0NaN45.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTASUDOESTE PIAUIENSESAO RAIMUNDO NONATOCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOPIPINaNNaNNaNNaNNaNNaN0210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
1NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2012-03-291865.61NaNNaNFalseTrueFalseFalseFalseFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN32e5f4e10932153a7ba869cb0386e7e02d49d2461046b8...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 106.586301NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN47.633333NaNNaNNaNNaNNaNNaNNaN22.427778NaNNaN58.666667NaNNaNNaNNaNNaN3.966667NaNNaNOUTROSCOMERCIO VAREJISTACENTRO MARANHENSEMEDIO MEARIMCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...22.0NaNNaN6.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN6.00.06.040.00.02.0NaNNaN2.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIOMAMANaNNaNNaNNaN-100.00.01210000.01000915.2NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
2NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOAZUL2010-10-26798.12NaNNaNFalseFalseFalseFalseTrueFalseTrueTrueTrueFalseSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaNa95d6f30bba445bd3d6b0c5b36f865b38ec01d17336090...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 108.010959NaN54.0NaNNaNNaN54.0NaN54.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTANORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...24.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOMAMANaNNaNNaNNaNNaNNaN250000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
3NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALALTACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2005-11-03608.47NaNNaNFalseFalseFalseFalseTrueFalseFalseTrueTrueFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN6cb309685cea0b6d2988818792ec2e6fcb2bd02e0afa9e...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2020.863014NaN40.0NaNNaNNaN40.0NaN40.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTAOESTE POTIGUARUMARIZALCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...26.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIORNRNNaNNaNNaNNaNNaNNaN350000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
4NaNNaNNaNNaNDE R$ 1.500.000,01 A R$ 4.800.000,00DE R$ 4.800.000,01 A R$ 10.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2005-11-03880.71NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseTrueFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaN11.03.0f72aa7fa6787b0a5a1c88885b6120850df8ee0f71adc25...NaNNaNNaN4.03.02.04.01.0NaNNaN15 a 2018.726027NaN33.0NaNNaNNaN33.0NaN33.0NaNNaNNaNNaN91.2166.433333NaNNaNNaNNaNNaNNaN39.45476228.986822NaNNaN19.333333NaNNaNNaNNaN19.3333330.233333NaNNaNENTIDADES EMPRESARIAISCOMERCIO VAREJISTALESTE POTIGUARNATALCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...23.085.7114.2943.00.0NaNNaNNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN29.00.028.0314.015.025.0NaNNaN28.0NaNNaN2.0NaN1.0NaNNaN2.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIORNRNNaN14.0NaN-6.666667-44.00.043029140.85872824.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
5NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXACOMERCIO VAREJISTAACIMA DE 1 ANOAZUL2012-08-031126.14NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseTrueFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaNf7e2894dce5dbb49662da50c55bcb96cdc3d34188abfe8...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 106.238356NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN17.133333NaNNaNNaNNaNNaNNaNNaN17.133333NaNNaN34.266667NaNNaNNaNNaNNaN17.133333NaNNaNOUTROSCOMERCIO VAREJISTASUL MARANHENSEGERAIS DE BALSASCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...25.0NaNNaN1.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1.00.01.000.00.01.0NaNNaN0.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIOMAMANaNNaNNaNNaN-100.00.05210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
6NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALALTACOMERCIO VAREJISTAACIMA DE 1 ANOAZUL2009-03-02NaNNaNNaNFalseTrueFalseFalseTrueFalseFalseFalseTrueFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaNf0c84600cbd2e126ee8314d22816368f33207e723a6ae7...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 109.663014NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTACENTRO AMAZONENSEMANAUSCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...21.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIOAMAMNaNNaNNaNNaNNaNNaN6210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
7NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTASEM INFORMACAOCINZA2018-04-30860.88NaNNaNFalseTrueFalseFalseTrueFalseTrueNaNNaNFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaNd0f8bc5c0e71600d303cacebb3e8e6fd9195322b2c1b15...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.495890NaN25.0NaNNaNNaN25.0NaN25.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTALESTE POTIGUARNATALCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIORNRNNaNNaNNaNNaNNaNNaN7210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
893.733333NaN93.733333NaNDE R$ 360.000,01 A R$ 1.500.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNSOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO VAREJISTAATE 1 ANOCINZA2017-08-30771.97210000.0210000.0FalseFalseFalseFalseTrueFalseFalseNaNNaNTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaN5.0NaNb9b02480a757c3cc5054d6c01e44df62b22ea1328a8743...NaNNaN4.01.0NaNNaNNaNNaNNaNNaN1 a 51.16164493.73333334.093.73333393.733333NaN34.093.73333334.0210000.0210000.0NaNNaN5.85.800000NaNNaN210000.0210000.0NaNNaN5.4066674.811111NaNNaN3.833333210000.0210000.0NaNNaN3.8333331.833333NaNNaNENTIDADES EMPRESARIAISCOMERCIO VAREJISTASUL MARANHENSEGERAIS DE BALSASCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...11.060.0040.006.06.0NaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.01.00.00.00.01.00.00.00.01.01.01.005.00.00.0NaNNaN5.01.01.02.01.01.0NaNNaN2.00.0NaNNaNNaNNaNNaN1.0NaN1.0COMERCIOMAMA210000.05.0NaNNaNNaN0.08927288.0927288.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
930.866667NaN30.866667NaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNSOCIEDADE EMPRESARIA LIMITADAMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOAZUL2013-07-08853.16210000.0210000.0FalseTrueFalseFalseTrueFalseFalseFalseTrueFalseSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN7d58990ba786a3a26617a8afbf814a9919ab34aa09013a...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 105.30958930.86666724.030.86666730.866667NaN24.030.86666724.0210000.0210000.0NaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNENTIDADES EMPRESARIAISCOMERCIO VAREJISTACENTRO NORTE PIAUIENSETERESINACOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...23.0NaNNaNNaNNaNNaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.01.00.00.00.00.00.01.00.00.01.00.00.00.00.00.00.00.0NaNNaNNaN0NaNNaNNaNNaNNaNNaN1.01.02.01.0NaN1.0NaN2.00.0NaNNaNNaNNaNNaN1.0NaN1.0COMERCIOPIPI210000.0NaNNaNNaNNaNNaN9210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0

Last rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadeUnnamed_0vl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
545NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOAMARELO2009-08-211043.68NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseTrueFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaNf1c4e9e123c2fa80339ad2a363ba133e4d936e6137d7b4...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 109.191781NaN53.0NaNNaNNaN53.0NaN53.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTACENTRO AMAZONENSEMANAUSCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...48.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOAMAMNaNNaNNaNNaNNaNNaN545210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
546NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXACOMERCIO VAREJISTAATE 1 ANOCINZA2017-02-21NaNNaNNaNFalseFalseFalseFalseTrueFalseTrueNaNNaNFalseNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN1c216b9c297273b5c220ccabba9d5fe11b3429d957b985...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 51.682192NaN50.0NaNNaNNaN50.0NaN50.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTASUDOESTE PIAUIENSESAO RAIMUNDO NONATOCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...7.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOPIPINaNNaNNaNNaNNaNNaN546210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
547NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXACOMERCIO VAREJISTAACIMA DE 1 ANOLARANJA2009-09-24NaNNaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseTrueFalseNaNNaN1.0NaNNaN5c1f7c821363f80755976616bd3b789c76d3b60021ef84...NaNNaNNaN1.0NaNNaNNaNNaNNaNNaN> 2021.158904NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN86.13333386.133333NaNNaNNaNNaNNaNNaN86.13333323.696296NaNNaN54.066667NaNNaNNaNNaN86.1333332.433333NaNNaNOUTROSCOMERCIO VAREJISTANaNNaNCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...23.0100.00.09.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN8.00.08.001.01.02.0NaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIORORONaN1.0NaN0.0-50.00.0547185457.6185457.6NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
548NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2016-12-191065.92NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseTrueFalseNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN0bb480303fa97577b8e25ae2c4ae8a2f04bff4095dc216...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 51.857534NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTANaNNaNCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...19.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIORORONaNNaNNaNNaNNaNNaN548210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
549NaNNaNNaNNaNNaNNaNNaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTASEM INFORMACAOCINZA2018-05-171098.56NaNNaNFalseFalseFalseFalseTrueFalseTrueNaNNaNFalseNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN3bf88877e71fb1bd4e0ce2e76ca432d788a3fab38078be...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.449315NaN37.0NaNNaNNaN37.0NaN37.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTALESTE POTIGUARLITORAL SULCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIORNRNNaNNaNNaNNaNNaNNaN549NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
550NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00BOASOCIEDADE EMPRESARIA LIMITADAMEDIABENS DE CONSUMOACIMA DE 1 ANOLARANJA2005-11-031585.53NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN4e2353206c04c6a8c097252c89f6970594f0796676bba5...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2027.660274NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES EMPRESARIAISCONFECCAO DE ARTIGOS DO VESTUARIO E ACESSORIOSNORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISINDUSTRIAS DE TRANSFORMACAO23.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNINDUSTRIAMAMANaNNaNNaNNaNNaNNaN550210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
551NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXACOMERCIO VAREJISTAATE 1 ANOCINZA2017-03-24552.94NaNNaNFalseTrueFalseFalseTrueFalseTrueNaNNaNFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN571a7461978f95114944695065e774a38f06528d287740...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 51.597260NaN40.0NaNNaNNaN40.0NaN40.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTALESTE MARANHENSECHAPADAS DO ALTO ITAPECURUCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...10.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOMAMANaNNaNNaNNaNNaNNaN551210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
552NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOAZUL2005-11-03NaNNaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN4fbebb5a4ea9d2c5da87f446aff48403f0409e2e8fe381...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2031.868493NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTACENTRO NORTE PIAUIENSETERESINACOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...47.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIOPIPINaNNaNNaNNaNNaNNaN552210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
553NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXACOMERCIO VAREJISTAATE 1 ANOCINZA2017-11-08606.29NaNNaNFalseTrueFalseFalseTrueFalseTrueNaNNaNTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN8bbff0a749bceb9749c5edd90373270ff9109f069ef27c...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.969863NaN34.0NaNNaNNaN34.0NaN34.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTAOESTE MARANHENSEPINDARECOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...9.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOMAMANaNNaNNaNNaNNaNNaN553210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
554NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2014-10-316201.91NaNNaNFalseFalseFalseFalseTrueFalseTrueTrueTrueFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN970485e6b8abe52d8fb4e0bf060fb6f0f4f8576cb7583d...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 53.994521NaN45.0NaNNaNNaN45.0NaN45.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTACENTRO NORTE PIAUIENSETERESINACOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...22.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOPIPINaNNaNNaNNaNNaNNaN55450000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0